package com.yangwudi.pojo;


import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.List;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class JobOption {
    private List jobList;   //职位列表
    private List dataList;  //数据列表
}


//
//SQL语句
//流程控制函数case: case 表达式 when val1 then result1 when val2 then result2 else result_else end
//或者:
//        case when job = 1 then '班主任' when job = 2 then '讲师' when job = 3 then '学工主管'
//when job = 4 then '教研主管' when job = 5 then '咨询师' else '其他' end
//
//
//
//select
//        (case
//         when job = 1 then '班主任'
//                 when job = 2 then '讲师'
//                 when job = 3 then '学工主管'
//                 when job = 4 then '教研主管'
//                 when job = 5 then '咨询师'
//                 else '其他'
//                 end) pos,
//count(*) num
//from emp group by job order by num ;

